package com.yf.mapper;

import com.yf.bean.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author : hzyao
 * @date : 16:36 2020/10/7
 */
@Mapper
public interface yfjxMapper {
//    查询9代
    @Select("select * from yfjx8 where CH8m=#{ch8} or CH8f=#{ch8}")
    List<yfjx8> getByLevel8(@Param("ch8") String ch8);
//    查询8代
    @Select("select * from yfjx8 where LH8=#{lh8}")
    yfjx8 getByLevel7(@Param("lh8") String lh8);
//    查询7代
    @Select("select * from yfjx7 where LH7=#{lh7}")
    yfjx7 getByLevel6(@Param("lh7") String lh7);
//    查询6代
    @Select("select * from yfjx6 where LH6=#{lh6}")
    yfjx6 getByLevel5(String lh6);
//    查询5代
    @Select("select * from yfjx5 where LH5=#{lh5}")
    yfjx5 getByLevel4(String lh5);
//    查询3代
    @Select("select * from yfjx4 where LH4=#{lh4}")
    yfjx4 getByLevel3(String lh4);

}
